﻿/*********************************************************************************************************************
VanguardDocumentation, Data for EntityPropertyRules

© 2014 Erik Ackerholm

This file is part of SqlVanguard.

SqlVanguard is free software: you can redistribute it and/or modify it under the terms of the GNU General Public 
License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later 
version.

SqlVanguard is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied 
warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with SqlVanguard. If not, see 
<http://www.gnu.org/licenses/>.
*********************************************************************************************************************/

declare @EntityPropertRules as table (
	Level0Type               varchar(64) not null,
	Level1Type               varchar(64) not null,
	Level2Type               varchar(64) not null,
	PropertyName             nvarchar(64) not null,
	Usage                    varchar(16) not null,
	MinSize                  integer not null,
	MaxSize                  integer not null,
	primary key (Level0Type, Level1Type, Level2Type, PropertyName)
);

-- Captions
insert into @EntityPropertyRules
values
	('', '', '', 'Caption', 'optional', 0, 
GO




